﻿ALTER TABLE [jnl].[Journal]
    ADD CONSTRAINT [DF_jnlJournal_InputBy] DEFAULT (lower(case when charindex('\',suser_sname())>(0) then substring(suser_sname(),charindex('\',suser_sname())+(1),(20)) else suser_sname() end)) FOR [InputBy];

